/*
 * Copyright 2017-2021 Dromara.org
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package org.dromara.hmily.tac.sqlcompute.impl;

import lombok.RequiredArgsConstructor;
import org.dromara.hmily.repository.spi.entity.HmilyDataSnapshot;
import org.dromara.hmily.repository.spi.entity.tuple.HmilySQLManipulation;
import org.dromara.hmily.repository.spi.entity.tuple.HmilySQLTuple;
import org.dromara.hmily.tac.sqlcompute.HmilySQLComputeEngine;
import org.dromara.hmily.tac.sqlcompute.exception.SQLComputeException;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.Collection;
import java.util.List;
import java.util.Map;

/**
 * Abstract hmily SQL compute engine.
 *
 * @author zhaojun
 */
@RequiredArgsConstructor
public abstract class AbstractHmilySQLComputeEngine implements HmilySQLComputeEngine {
    
    @Override
    public HmilyDataSnapshot execute(final String sql, final List<Object> parameters, final Connection connection, final String resourceId) throws SQLComputeException {
        HmilyDataSnapshot result = new HmilyDataSnapshot();
        try {
            result.getTuples().addAll(createTuples(sql, parameters, connection, resourceId));
        } catch (final SQLException ex) {
            throw new SQLComputeException(ex);
        }
        return result;
    }
    
    /**
     * Build tuple.
     *
     * @param tableName table name
     * @param manipulation manipulation
     * @param primaryKeyValues primary key values
     * @param before before
     * @param after after
     * @return hmily SQL tuple
     */
    protected HmilySQLTuple buildTuple(final String tableName, final HmilySQLManipulation manipulation,
                                     final List<Object> primaryKeyValues, final Map<String, Object> before, final Map<String, Object> after) {
        HmilySQLTuple result = new HmilySQLTuple();
        result.setTableName(tableName);
        result.setManipulationType(manipulation);
        result.setPrimaryKeyValues(primaryKeyValues);
        result.setBeforeImage(before);
        result.setAfterImage(after);
        return result;
    }
    
    abstract Collection<HmilySQLTuple> createTuples(String sql, List<Object> parameters, Connection connection, String resourceId) throws SQLException;
}
